2013-04-10 - 5910.200 - Rel Notes - Contracts - Release 030 #BIReleases2013
Release Notes:
5910.200 - SA110 - Corporate Scorecard
Admin Info
Purpose
|
Including Contract Information in SA100 - Coorporate Scorecard
|
Release No
|
030
|
Submitted
|
04-10-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Praveen Guntuka
|
Report Name
SA110 - Corporate Scorecard
BEx Query
ZMP_OOCON_Q001
ZMP_OOCON_Q002
NEC Crystal Reports Standards Check
1. SA110 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA110 NEC CR checklist has been sent to NEC and also attached here for reference:
SA110 NEC CR Standard Check List.xlsx
Excel Files
ProfitCenters.xls
ScorecardDatasource.xls
Retails.xls
Combined.xls
SAPOpenOrders.xls
ScorecardDataByCountry.xls
ScorecardDataByRegion.xls
Main Report Validation
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Scorecard Data Source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
16,660,181
|
16,660,180.57
|
Pass
|
2
|
MTD > Last Year
|
48,082,506
|
48,082,506.0882
|
Pass
|
3
|
MTD > Budget
|
56,220,389
|
56,220,388.53
|
Pass
|
4
|
MTD > Projected
|
43,238,623
|
43,238,623.12
|
Pass
|
5
|
YTD > This Year
|
176,417,116
|
176,417,116.286
|
Pass
|
6
|
YTD > Last Year
|
202,675,220
|
202,675,220.12
|
Pass
|
7
|
YTD > Budget
|
242,520,952
|
242,520,952.1
|
Pass
|
8
|
YTD > Projected
|
202,995,558
|
202,995,558.406
|
Pass
|
Regional Sub Report Validation
Test Conducted
NORTH AMERICA
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Scorecard Data Source
|
Pass/Fail Criteria
|
1
|
This Year
|
12,934,903
|
12,934,903
|
Pass
|
2
|
Last Year
|
34,553,934
|
34,553,934
|
Pass
|
3
|
Budget
|
40,693,960
|
40,693,960
|
Pass
|
4
|
Projected
|
29,674,888
|
29,674,888
|
Pass
|
5
|
This Year
|
137,298,926
|
137,298,926
|
Pass
|
6
|
Last Year
|
162,123,673
|
162,123,673
|
Pass
|
7
|
Budget
|
194,123,673
|
194,123,673
|
Pass
|
8
|
Projected
|
154,038,911
|
154,038,911
|
Pass
|
EMERGING MARKETS
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Scorecard Data Source
|
Pass/Fail Criteria
|
1
|
This Year
|
1,080,555
|
1,080,555
|
Pass
|
2
|
Last Year
|
4,625,384
|
4,625,384
|
Pass
|
3
|
Budget
|
4,922,823
|
4,922,823
|
Pass
|
4
|
Projected
|
4,498,232
|
4,498,232
|
Pass
|
5
|
This Year
|
13,565,764
|
13,565,764
|
Pass
|
6
|
Last Year
|
11,517,017
|
11,517,017
|
Pass
|
7
|
Budget
|
13,864,051
|
13,864,051
|
Pass
|
8
|
Projected
|
16,983,441
|
16,983,441
|
Pass
|
ProductCategory Sub report validation
Test Conducted
HEADWEAR
SNo
|
Test Case
|
Value in CR
|
Value in ScorecardData Source
|
Pass/Fail Criteria
|
1
|
This Year
|
14,990,994
|
14,990,994
|
Pass
|
2
|
Last Year
|
40,212,393
|
40,212,393
|
Pass
|
3
|
Budget
|
47,527,938
|
47,527,938
|
Pass
|
4
|
Projected
|
38,541,555
|
38,541,555
|
Pass
|
5
|
This Year
|
147,228,990
|
147,228,990
|
Pass
|
6
|
Last Year
|
166,724,636
|
166,724,636
|
Pass
|
7
|
Budget
|
202,120,789
|
202,120,789
|
Pass
|
8
|
Projected
|
170,779,551
|
170,779,551
|
Pass
|
APPAREL >PINK
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Scorecard Data Source
|
Pass/Fail Criteria
|
1
|
This Year
|
85,175
|
85,175
|
Pass
|
2
|
Last Year
|
0
|
0
|
Pass
|
3
|
Budget
|
3,265,467
|
3,265,467
|
Pass
|
4
|
Projected
|
1,350,659
|
1,350,659
|
Pass
|
5
|
This Year
|
10,591,976
|
10,591,976
|
Pass
|
6
|
Last Year
|
0
|
0
|
Pass
|
7
|
Budget
|
17,502,012
|
17,502,012
|
Pass
|
8
|
Projected
|
11,857,460
|
11,857,460
|
Pass
|
NextPeriodRegional Sub report validation
Test Conducted
NORTH AMERICA
SNo
|
Test Case
|
Value in CR
|
Value in Scorecard Data sheet
|
Pass/Fail Criteria
|
1
|
Last Year
|
39,099,159
|
39,099,159
|
Pass
|
2
|
Budget
|
50,192,627
|
50,192,627
|
Pass
|
3
|
Projected
|
25,330,015
|
25,330,015
|
Pass
|
EMEA
SNo
|
Test Case
|
Value in CR
|
Value in Scorecard data sheet
|
Pass/Fail Criteria
|
1
|
Last Year
|
5,562,587
|
5,562,587
|
Pass
|
2
|
Budget
|
6,693,985
|
6,693,985
|
Pass
|
3
|
Projected
|
4,175,796
|
4,175,796
|
Pass
|
NextPeriodCategory Sub report validation
Test Conducted
HEADWEAR
SNo
|
Test Case
|
Value in CR
|
Value in Scorecard data sheet
|
Pass/Fail Criteria
|
1
|
Last Year
|
45,604,624
|
45,604,624
|
Pass
|
2
|
Budget
|
51,754,795
|
51,754,795
|
Pass
|
3
|
Projected
|
28,651,739
|
28,651,739
|
Pass
|
APPAREL > WOMEN
SNo
|
Test Case
|
Value in CR
|
Value in Scorecard data sheet
|
Pass/Fail Criteria
|
1
|
Last Year
|
950,739
|
950,739
|
Pass
|
2
|
Budget
|
4,364,399
|
4,364,399
|
Pass
|
3
|
Projected
|
1,462,053
|
1,462,053
|
Pass
|
Shipped_Open Sub report validation
Test Conducted
NEW ERA > Open Orders
SNo
|
Test Case
|
Value in CR
|
Value in Scorecard data sheet
|
Pass/Fail Criteria
|
1
|
Jun
|
35,598,636
|
45,604,624
|
Pass
|
2
|
Jul
|
23,810,047
|
23,810,047
|
Pass
|
3
|
Aug
|
25,955,058
|
25,955,058
|
Pass
|
4
|
Total
|
356,773,641
|
356,773,641
|
Pass
|
NEW ERA > Last Yr Shipped
SNo
|
Test Case
|
Value in CR
|
Value in Scorecard data sheet
|
Pass/Fail Criteria
|
1
|
Jun
|
61,528,297
|
61,528,297
|
Pass
|
2
|
Jul
|
54,300,574
|
54,300,574
|
Pass
|
3
|
Aug
|
59,535,855
|
59,535,855
|
Pass
|
4
|
Total
|
641,030,888
|
641,030,888
|
Pass
|
NEW ERA > Budget
SNo
|
Test Case
|
Value in CR
|
Value in Scorecard data sheet
|
Pass/Fail Criteria
|
1
|
Jun
|
68,445,409
|
68,445,409
|
Pass
|
2
|
Jul
|
64,161,583
|
64,161,583
|
Pass
|
3
|
Aug
|
66,551,857
|
66,551,857
|
Pass
|
4
|
Total
|
727,069,693
|
727,069,693
|
Pass
|
NEW ERA > % of Last Yr
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Jun
|
57.86%
|
57.86%
|
Pass
|
2
|
Jul
|
43.86%
|
43.86%
|
Pass
|
3
|
Aug
|
43.60%
|
43.60%
|
Pass
|
4
|
Total
|
55.66%
|
55.66%
|
Pass
|
NEW ERA > % of Budget
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Jun
|
52.01%
|
52.01%
|
Pass
|
2
|
Jul
|
37.11%
|
37.11%
|
Pass
|
3
|
Aug
|
39.00%
|
39.00%
|
Pass
|
4
|
Total
|
49.07%
|
49.07%
|
Pass
|
Main Report validation
Test Conducted
HEADWEAR
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Scorecard Data Source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
14,990,994
|
14,990,994
|
Pass
|
2
|
MTD > Last Year
|
40,212,393
|
40,212,393
|
Pass
|
3
|
MTD > Budget
|
47,527,938
|
47,527,938
|
Pass
|
4
|
YTD > This Year
|
147,228,990
|
147,228,990
|
Pass
|
5
|
YTD > Last Year
|
166,724,636
|
166,724,636
|
Pass
|
6
|
YTD > Budget
|
202,120,789
|
202,120,789
|
Pass
|
HEADWEAR > NORTH AMERICA
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Scorecard Data Source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
11,947,904
|
11,947,904
|
Pass
|
2
|
MTD > Last Year
|
29,463,748
|
29,463,748
|
Pass
|
3
|
MTD > Budget
|
34,098,877
|
34,098,877
|
Pass
|
5
|
YTD > This Year
|
112,142,176
|
112,142,176
|
Pass
|
6
|
YTD > Last Year
|
132,555,024
|
132,555,024
|
Pass
|
7
|
YTD > Budget
|
159,846,316
|
159,846,316
|
Pass
|
HEADWEAR > NORTH AMERICA > LIFESTYLE
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Scorecard Data Source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
5,298,317
|
5,298,317
|
Pass
|
2
|
MTD > Last Year
|
12,598,751
|
12,598,751
|
Pass
|
3
|
MTD > Budget
|
15,098,344
|
15,098,344
|
Pass
|
4
|
YTD > This Year
|
45,566,621
|
45,566,621
|
Pass
|
5
|
YTD > Last Year
|
58,996,005
|
58,996,005
|
Pass
|
6
|
YTD > Budget
|
65,146,420
|
65,146,420
|
Pass
|
Retails Sub Report validation
Test Conducted
NEW ERA > Day
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Retail Source
|
Pass/Fail Criteria
|
1
|
Units
|
600
|
600
|
Pass
|
2
|
TY
|
15,602
|
15,602
|
Pass
|
3
|
LY
|
19,701
|
19,701
|
Pass
|
4
|
% to LY
|
-21%
|
-21%
|
Pass
|
NEW ERA > Month-To-Date
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Retail Data Source
|
Pass/Fail Criteria
|
1
|
Units
|
11,776
|
11,776
|
Pass
|
2
|
TY
|
381,754
|
381,754
|
Pass
|
3
|
LY
|
361,541
|
361,541
|
Pass
|
4
|
% to LY
|
6%
|
6%
|
Pass
|
NEW ERA > Year-To-Date
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/Retail source
|
Pass/Fail Criteria
|
1
|
Units
|
32,492
|
32,492
|
Pass
|
2
|
TY
|
1.079.992
|
1.079.992
|
Pass
|
3
|
LY
|
922,209
|
922,209
|
Pass
|
4
|
% to LY
|
17%
|
17%
|
Pass
|
OpenOrderSubReport validation
Test Conducted
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
NORTH AMERICA > WEEK ENDING Apr 07 > Total Open Value
|
3,506,737
|
3,506,736.93
|
Pass
|
2
|
NORTH AMERICA > WEEK ENDING Apr 14 > Total Open Quantity
|
453,217
|
453,217
|
Pass
|
3
|
EMEA > WEEK ENDING Apr 14 > Total Open Value
|
2,830,690
|
2,830,689.79
|
Pass
|
4
|
EMEA > WEEK ENDING Apr 21 > Total Open Quantity
|
135,198
|
135,198
|
Pass
|
5
|
EMERGING MARKETS > WEEK ENDING Apr 21 > Total Open Value
|
595,221
|
595,221.30
|
Pass
|
6
|
EMERGING MARKETS > WEEK ENDING Apr 28 > Total Open Quantity
|
25,182
|
25,182
|
Pass
|
7
|
Total > WEEK ENDING Apr 07 > Total Open Value
|
4,345,300
|
4,345,300
|
Pass
|
8
|
Total > WEEK ENDING Apr 07 > Total Open Quantity
|
381,283
|
381,283
|
Pass
|
9
|
Total > WEEK ENDING Apr 14 > Total Open Value
|
8,021,989
|
8,021,989
|
Pass
|
10
|
Total > WEEK ENDING Apr 14 > Total Open Quantity
|
682,737
|
682,737
|
Pass
|
11
|
Total > WEEK ENDING Apr 21 > Total Open Value
|
5,637,817
|
5,637,817
|
Pass
|
12
|
Total > WEEK ENDING Apr 21 > Total Open Quantity
|
498,030
|
498,030
|
Pass
|
13
|
Total > WEEK ENDING Apr 28 > Total Open Value
|
5,433,505
|
5,433,505
|
Pass
|
14
|
Total > WEEK ENDING Apr 28 > Total Open Quantity
|
640,746
|
640,746
|
Pass
|
15
|
Total > NORTH AMERICA > Total Open Value
|
18,027,025
|
16,739,984.88
|
Pass
|
16
|
Total > NORTH AMERICA > Total Open Quantity
|
1,821,892
|
1,695,136
|
Pass
|
17
|
Total > EMEA > Total Open Value
|
4,935,061
|
4,935,060.92
|
Pass
|
18
|
Total > EMEA > Total Open Quantity
|
384,906
|
384,906
|
Pass
|
19
|
Total > EMERGING MARKETS > Total Open Value
|
1,765,565
|
1,765,565
|
Pass
|
20
|
Total > EMERGING MARKETS > Total Open Quantity
|
122,754
|
122,754
|
Pass
|
OpenOrderSub2 Report Validation
Test Conducted
2013 > Apr > Total
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/SAPOpenOrders source
|
Pass/Fail Criteria
|
1
|
NORTH AMERICA
|
16,739,985
|
16,739,985
|
Pass
|
2
|
EMEA
|
4,930,133
|
4,930,133
|
Pass
|
3
|
JAPAN
|
41,490,647
|
41,490,647
|
Pass
|
4
|
EMERGING MARKETS
|
3,417,677
|
3,417,677
|
Pass
|
2013 > Apr > NA
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/SAPOpenOrders source
|
Pass/Fail Criteria
|
1
|
NORTH AMERICA
|
14,323
|
14,323
|
Pass
|
2
|
EMEA
|
47,739
|
47,739
|
Pass
|
3
|
JAPAN
|
159,543
|
159,543
|
Pass
|
4
|
EMERGING MARKETS
|
39,134
|
39,134
|
Pass
|
2013 > Apr > APP
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/SAPOpenOrders source
|
Pass/Fail Criteria
|
1
|
NORTH AMERICA
|
2,292,687
|
2,292,687
|
Pass
|
2
|
EMEA
|
110,332
|
110,332
|
Pass
|
3
|
JAPAN
|
48,311
|
48,311
|
Pass
|
4
|
EMERGING MARKETS
|
315,813
|
315,813
|
Pass
|
2013 > Apr > HW
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/SAPOpenOrders source
|
Pass/Fail Criteria
|
1
|
NORTH AMERICA
|
14,432,975
|
14,432,975
|
Pass
|
2
|
EMEA
|
4,772,063
|
4,772,063
|
Pass
|
3
|
JAPAN
|
1,282,793
|
1,282,793
|
Pass
|
4
|
EMERGING MARKETS
|
3,062,731
|
3,062,731
|
Pass
|
Hot Market Open Orders by Collection and Team
Test Conducted
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
NBA WHITEOUT > No. of Orders
|
8
|
8
|
Pass
|
2
|
NBA WHITEOUT > Confirmed Qty
|
1,092
|
1,092
|
Pass
|
3
|
NBA WHITEOUT > Total Open Value
|
11,466
|
11,466.00
|
Pass
|
4
|
SB CHASE > BALTIMORE RAVENS > No. of Orders
|
17
|
17
|
Pass
|
5
|
SB CHASE > BALTIMORE RAVENS > Confirmed Qty
|
1,126
|
1,126
|
Pass
|
6
|
SB CHASE > BALTIMORE RAVENS >Total Open Value
|
16,192
|
16,192.08
|
Pass
|
7
|
Hot Market Grand Total > No. of Orders
|
32
|
32
|
Pass
|
8
|
Hot Market Grand Total > Confirmed Qty
|
2,464
|
2,464
|
Pass
|
9
|
Hot Market Grand Total > Total Open Value
|
30,662
|
30,661.76
|
Pass
|
Top 15 Countries Report Validation
Test Conducted
NEW ERA
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/ScorcardByCountry source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
16,278,459
|
16,278,459
|
Pass
|
2
|
MTD > Last Year
|
47,720,970
|
47,720,970
|
Pass
|
3
|
YTD > This Year
|
175,337,139
|
175,337,139
|
Pass
|
4
|
YTD > Last Year
|
201,753,026
|
201,753,026
|
Pass
|
NEW ERA > NETHERLANDS
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/ ScorecardDataByCountry source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
185,299
|
185,299
|
Pass
|
2
|
MTD > Last Year
|
820,412
|
820,412
|
Pass
|
3
|
YTD > This Year
|
2,326,881
|
2,326,881
|
Pass
|
4
|
YTD > Last Year
|
3,462,838
|
3,462,838
|
Pass
|
Customer Group 9 Regions Report Validation
Test Conducted
NEW ERA
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/ScorcardByRegion source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
16,278,459
|
16,278,459
|
Pass
|
2
|
MTD > Last Year
|
47,720,970
|
47,720,970
|
Pass
|
3
|
YTD > This Year
|
175,337,139
|
175,337,139
|
Pass
|
4
|
YTD > Last Year
|
201,753,026
|
201,753,026
|
Pass
|
NEW ERA > North America
SNo
|
Test Case
|
Value in CR
|
Value from Sheet/ ScorecardDataByRegion source
|
Pass/Fail Criteria
|
1
|
MTD > This Year
|
12,934,780
|
12,934,780
|
Pass
|
2
|
MTD > Last Year
|
3,354,484
|
3,354,484
|
Pass
|
3
|
YTD > This Year
|
137,280,238
|
137,280,238
|
Pass
|
4
|
YTD > Last Year
|
161,753,331
|
161,753,331
|
Pass
|
Reference Document(Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports